<?php

class wap_tag {
private $db;
public function __construct() {
$this->db = h5_base::load_model('content_model');
$this->position = h5_base::load_model('position_data_model');
}
public function set_modelid($catid) {
$siteids = getcache('category_content','commons');
$siteid = $siteids[$catid];
$this->category = getcache('category_content_'.$siteid,'commons');
$this->modelid = $this->category[$catid]['modelid'];
$this->db->set_model($this->modelid);
$this->tablename = $this->db->table_name;
}
public function count($data) {
if($data['action'] == 'lists') {
if(isset($data['where'])) {
$sql = $data['where'];
}else {
$TYPES = getcache('wap_type','wap');
$TYPE = $TYPES[$data['typeid']];
$catid = intval($TYPE['cat']);
$this->set_modelid($catid);
if(!$this->category[$catid]) return false;
if($this->category[$catid]['child']) {
$catids_str = $this->category[$catid]['arrchildid'];
$pos = strpos($catids_str,',')+1;
$catids_str = substr($catids_str,$pos);
$sql = "status=99 AND catid IN ($catids_str)";
}else {
$sql = "status=99 AND catid='$catid'";
}
}
return $this->db->count($sql);
}
}
public function type($data) {
$siteid = $data['siteid'] = intval(trim($data['siteid']))!== 0 ?intval(trim($data['siteid'])) : 1;
$TYPES = getcache('wap_type','wap');
$i = 1;
if(is_array($TYPES) &&!empty($TYPES)) {
foreach ($TYPES as $typeid=>$type) {
if($i>$data['limit']) break;
if($siteid &&$type['siteid']!=$siteid) continue;
if($type['parentid']==$data['typeid']) {
$array[$typeid] = $type;
$i++;
}
}
}
return $array;
}
public function lists($data) {
$data['siteid'] = intval(trim($data['siteid']))!== 0 ?intval(trim($data['siteid'])) : 1;
$TYPES = getcache('wap_type','wap');
$TYPE = $TYPES[$data['typeid']];
if(isset($data['where'])) {
$sql = $data['where'];
}else {
$child = subtype($data['typeid']);
$catid = intval($TYPE['cat']);
$this->set_modelid($catid);
if(!$this->category[$catid]) return false;
if(is_array($child) &&count($child) >0 ) {
foreach ($child as $_k) $catids_str .= ','.$_k['cat'];
$pos = strpos($catids_str,',')+1;
$catids_str = substr($catids_str,$pos);
$sql = "status=99 AND catid IN ($catids_str)".$thumb;
}else {
$sql = "status=99 AND catid='$catid'".$thumb;
}
}
$order = $data['order'];
$return = $this->db->select($sql,'*',$data['limit'],$order,'','id');
if (isset($data['moreinfo']) &&intval($data['moreinfo']) == 1) {
$ids = array();
foreach ($return as $v) {
if (isset($v['id']) &&!empty($v['id'])) {
$ids[] = $v['id'];
}else {
continue;
}
}
if (!empty($ids)) {
$this->db->table_name = $this->db->table_name.'_data';
$ids = implode('\',\'',$ids);
$r = $this->db->select("`id` IN ('$ids')",'*','','','','id');
if (!empty($r)) {
foreach ($r as $k=>$v) {
if (isset($return[$k])) $return[$k] = array_merge($v,$return[$k]);
}
}
}
}
return $return;
}
public function position($data) {
$sql = '';
$array = array();
$posid = intval($data['posid']);
$order = $data['order'];
$thumb = (empty($data['thumb']) ||intval($data['thumb']) == 0) ?0 : 1;
$siteid = $GLOBALS['siteid'] ?$GLOBALS['siteid'] : 1;
$catid = (empty($data['catid']) ||$data['catid'] == 0) ?'': intval($data['catid']);
if($catid &&$this->category[$catid]['child']) {
$catids_str = $this->category[$catid]['arrchildid'];
$pos = strpos($catids_str,',')+1;
$catids_str = substr($catids_str,$pos);
$sql = "`catid` IN ($catids_str) AND ";
}elseif($catid &&!$this->category[$catid]['child']) {
$sql = "`catid` = '$catid' AND ";
}
if($thumb) $sql .= "`thumb` = '1' AND ";
$sql .= "`posid` = '$posid' AND `siteid` = '".$siteid."'";
$pos_arr = $this->position->select($sql,'*',$data['limit'],$order);
if(!empty($pos_arr)) {
foreach ($pos_arr as $info) {
$key = $info['catid'].'-'.$info['id'];
$array[$key] = string2array($info['data']);
$array[$key]['url'] = show_url($info['catid'],$info['id']);
}
}
return $array;
}
?>